***********************************************
**RESTORING TRUST IN MEXICO’S POLICE***********
**Authors: Ana I. López García & Sarah Berens**
***********************************************

******************
**BALANCE CHECKS**
******************

use "Data ready E6.dta", clear 

********************************************************
*1.Balance Checks
tabulate E6_vign1 E6_vign2, summarize(E6_police_eff)

tabulate E6_vign1 E6_vign2, summarize(E6_police_misc)

*Balance tests - vign 1
iebaltab E6_police_eff E6_police_misc female age_groups1 age_groups2 age_groups3 age_groups4 age_groups5 edlevel1 edlevel2 edlevel3 edlevel4 ///
	college_higher income_cat1 income_cat2 income_cat3 employed migrant, grpvar(E6_vign1) save("TableA2.xlsx") replace starl(0.05 0.010 0.001) rowvarlabels 

*Balance tests - vign 2
iebaltab E6_police_eff E6_police_misc female age_groups1 age_groups2 age_groups3 age_groups4 age_groups5 edlevel1 edlevel2 edlevel3 edlevel4 ///
	college_higher income_cat1 income_cat2 income_cat3 employed migrant, grpvar(E6_vign2) save("TableA3.xlsx") replace starl(0.05 0.010 0.001) rowvarlabels 
	
